<?php

    // 从前端获取数据
    $name = $_GET['name'];
    $price = $_GET['price'];
    $num = $_GET['num'];
    $size = $_GET['size'];

     // 连接数据库
     $conn = mysqli_connect('localhost', 'root', 'root', 'praday01');

     // 设置编码
     mysqli_query($conn, "set charset 'utf8'");
     mysqli_query($conn, "set character set 'utf8'");
 
     // 设置sql语句
     $sql = "insert into shop (name,price,num,size) values ('$name',$price,$num,'$size')";
 
     // 执行sql语句
     $res = mysqli_query($conn, $sql);

    // insert执行后返回布尔值
    if ($res) {
        echo json_encode(array(
            "code" => 200,
            "body" => array(
                "msg" => "添加成功"
            )
        ));
    } else {
        echo json_encode(array(
            "code" => 205,
            "body" => array(
                "msg" => "网络错误，添加失败"
            )
        ));
    }

?>